EXEC sp_refreshview [SEBrowser.WidgetView]

CREATE Table [ExternalDatabases] (
    ID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
    Name varchar(200) NOT NULL,
    Schedule varchar(50) NULL DEFAULT(NULL),
    ConnectionString Varchar(MAX) NOT NULL,
    DataProviderString VARCHAR(MAX) NULL,
    Encrypt bit NOT NULL DEFAULT(0),
    LastDataUpdate DATETIME2 NULL DEFAULT(NULL),
    Constraint UC_ExternalDatabase UNIQUE(Name)
)

UPDATE AssetType SET ID = 9 WHERE Name = 'StationAux'
GO

UPDATE AssetType SET ID = 10 WHERE Name = 'StationBattery'
GO

UPDATE AssetType SET ID = 11 WHERE Name = 'Generation'
GO